<?php 
$this->E_D("DROP TABLE IF EXISTS `db_cms_work`;");
$this->E_C("CREATE TABLE `db_cms_work` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `catid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `modelid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `thumb` varchar(255) NOT NULL DEFAULT '',
  `link` varchar(255) NOT NULL DEFAULT '',
  `titleurl` varchar(255) NOT NULL DEFAULT '',
  `newstime` int(11) unsigned NOT NULL DEFAULT '0',
  `pagetitle` varchar(255) NOT NULL DEFAULT '',
  `keywords` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `pubid` bigint(15) unsigned NOT NULL DEFAULT '0',
  `sort` int(11) unsigned NOT NULL DEFAULT '0',
  `userid` int(11) unsigned NOT NULL DEFAULT '0',
  `username` char(20) NOT NULL DEFAULT '',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0',
  `editortime` int(10) unsigned NOT NULL DEFAULT '0',
  `is_good` int(11) NOT NULL DEFAULT '0' COMMENT '推荐',
  `is_top` int(11) NOT NULL DEFAULT '0' COMMENT '置顶',
  `views` int(11) NOT NULL DEFAULT '0' COMMENT '点击总数',
  `goods` int(11) NOT NULL DEFAULT '0' COMMENT '点赞数',
  `favs` int(11) NOT NULL DEFAULT '0' COMMENT '收藏数',
  `comments` int(11) NOT NULL DEFAULT '0' COMMENT '评论数',
  `viewtemp` int(11) NOT NULL DEFAULT '0' COMMENT '单独内容模板',
  `description1` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `catid` (`catid`),
  KEY `sort` (`sort`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='table'");
$this->E_D("replace into `db_cms_work` values('1','127','64','Research','/upload/image/20211118/ae8c2fcbcff8bc583e545e24b86b0328.jpg','','','1637219932','','','','16372199323756','1','1','admin','1637747389','1637747389','0','0','0','0','0','0','0','Comax''s R&D department needs someone who love innovation, professional and have insight. Join us. Inject your skills, experience and care to the products.');");
$this->E_D("replace into `db_cms_work` values('2','127','64','engineering','/upload/image/20211118/10b4460990f0ce774b5657ec7bcc3b2f.jpg','','','1637220007','','','','16372200079733','2','1','admin','1637747404','1637747404','0','0','0','0','0','0','0','Comax needs some preofessional and meticulous engineers. Join us to build the most efficient and secure pig farm for our clients. ');");
$this->E_D("replace into `db_cms_work` values('3','127','64','Internet of Things','/upload/image/20211118/a31f4a2957c64958ab8434b915d35826.jpg','','','1637220025','','','','16372200251666','3','1','admin','1637747422','1637747422','0','0','0','0','0','0','0','Comax wants someone who pursues perfection, has a vision in our IoTs team. Through refining the production process, we will move towards a new generation of farming with our clients.');");
$this->E_D("replace into `db_cms_work` values('4','127','64','manufacturing','/upload/image/20211118/8eb9d60abc442e5c25eb4c695d120326.jpg','','','1637220042','','','','16372200424296','4','1','admin','1637747436','1637747436','0','0','0','0','0','0','0','Cologne needs meticulous manufacturing workers. Please join our manufacturing team to produce high-quality, credible and durable products for customers.');");

 ?>